begin tran
declare @upd_id int
select @upd_id = convert(int, var_data) from igs_parm with(updlock) where var_name = 'gv_upd_id'

--select * from ms_style_type where style_type like '%-PP%'

update ms_style_type set style_type = replace(style_type,'-PP','-LP'), upd_id = @upd_id where style_type like '%-PP%'
update ms_style_type set type_tree = replace(type_tree,'-PP','-LP'), upd_id = @upd_id where type_tree like '%-PP%'

select * from ms_style_type where style_type like '%-PP%' or style_type like '%-LP%'
select * from ms_style_type where type_tree like '%-PP%' or type_tree like '%-LP%'
commit tran